{% for join_algorithm in ['full_sorting_merge', 'grace_hash'] -%}
--- {{ join_algorithm }} ---
{% for block_size in range(1, 11, 4) -%}
t1 ALL INNER JOIN t2 | bs = {{ block_size }}
1	1	4	5
1	1	4	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
3	3	4	4
t1 ALL LEFT JOIN t2 | bs = {{ block_size }}
1	1	val1	5
1	1	val1	5
2	2	val21	5
2	2	val21	5
2	2	val21	5
2	2	val21	5
2	2	val21	5
2	2	val21	5
2	2	val21	5
2	2	val22	5
2	2	val22	5
2	2	val22	5
2	2	val22	5
2	2	val22	5
2	2	val22	5
2	2	val22	5
2	2	val23	5
2	2	val23	5
2	2	val23	5
2	2	val23	5
2	2	val23	5
2	2	val23	5
2	2	val23	5
2	2	val24	5
2	2	val24	5
2	2	val24	5
2	2	val24	5
2	2	val24	5
2	2	val24	5
2	2	val24	5
2	2	val25	5
2	2	val25	5
2	2	val25	5
2	2	val25	5
2	2	val25	5
2	2	val25	5
2	2	val25	5
2	2	val26	5
2	2	val26	5
2	2	val26	5
2	2	val26	5
2	2	val26	5
2	2	val26	5
2	2	val26	5
2	2	val27	5
2	2	val27	5
2	2	val27	5
2	2	val27	5
2	2	val27	5
2	2	val27	5
2	2	val27	5
3	3	val3	4
t1 ALL RIGHT JOIN t2 | bs = {{ block_size }}
1	1	4	val11
1	1	4	val12
2	2	5	val22
2	2	5	val22
2	2	5	val22
2	2	5	val22
2	2	5	val22
2	2	5	val22
2	2	5	val22
2	2	5	val23
2	2	5	val23
2	2	5	val23
2	2	5	val23
2	2	5	val23
2	2	5	val23
2	2	5	val23
2	2	5	val24
2	2	5	val24
2	2	5	val24
2	2	5	val24
2	2	5	val24
2	2	5	val24
2	2	5	val24
2	2	5	val25
2	2	5	val25
2	2	5	val25
2	2	5	val25
2	2	5	val25
2	2	5	val25
2	2	5	val25
2	2	5	val26
2	2	5	val26
2	2	5	val26
2	2	5	val26
2	2	5	val26
2	2	5	val26
2	2	5	val26
2	2	5	val27
2	2	5	val27
2	2	5	val27
2	2	5	val27
2	2	5	val27
2	2	5	val27
2	2	5	val27
2	2	5	val28
2	2	5	val28
2	2	5	val28
2	2	5	val28
2	2	5	val28
2	2	5	val28
2	2	5	val28
3	3	4	val3
t1 ANY INNER JOIN t2 | bs = {{ block_size }}
1	1	4	5
2	2	5	5
3	3	4	4
t1 ANY LEFT JOIN t2 | bs = {{ block_size }}
1	1	val1	5
2	2	val21	5
2	2	val22	5
2	2	val23	5
2	2	val24	5
2	2	val25	5
2	2	val26	5
2	2	val27	5
3	3	val3	4
t1 ANY RIGHT JOIN t2 | bs = {{ block_size }}
1	1	4	val11
1	1	4	val12
2	2	5	val22
2	2	5	val23
2	2	5	val24
2	2	5	val25
2	2	5	val26
2	2	5	val27
2	2	5	val28
3	3	4	val3
t1 ALL FULL JOIN t2 | bs = {{ block_size }}
1	1	4	5
1	1	4	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
2	2	5	5
3	3	4	4
t1 ALL FULL JOIN USING t2 | bs = {{ block_size }}
1	4	5
1	4	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
2	5	5
3	4	4
t1 ALL INNER JOIN tn2 | bs = {{ block_size }}
1	1	4	5
1	1	4	5
3	3	4	4
t1 ALL LEFT JOIN tn2 | bs = {{ block_size }}
1	1	val1	5
1	1	val1	5
2	\N	val21	0
2	\N	val22	0
2	\N	val23	0
2	\N	val24	0
2	\N	val25	0
2	\N	val26	0
2	\N	val27	0
3	3	val3	4
t1 ALL RIGHT JOIN tn2 | bs = {{ block_size }}
0	\N	0	val22
0	\N	0	val23
0	\N	0	val24
0	\N	0	val25
0	\N	0	val26
0	\N	0	val27
0	\N	0	val28
1	1	4	val11
1	1	4	val12
3	3	4	val3
t1 ANY INNER JOIN tn2 | bs = {{ block_size }}
1	1	4	5
3	3	4	4
t1 ANY LEFT JOIN tn2 | bs = {{ block_size }}
1	1	val1	5
2	\N	val21	0
2	\N	val22	0
2	\N	val23	0
2	\N	val24	0
2	\N	val25	0
2	\N	val26	0
2	\N	val27	0
3	3	val3	4
t1 ANY RIGHT JOIN tn2 | bs = {{ block_size }}
0	\N	0	val22
0	\N	0	val23
0	\N	0	val24
0	\N	0	val25
0	\N	0	val26
0	\N	0	val27
0	\N	0	val28
1	1	4	val11
1	1	4	val12
3	3	4	val3
t1 ALL FULL JOIN tn2 | bs = {{ block_size }}
0	\N	0	5
0	\N	0	5
0	\N	0	5
0	\N	0	5
0	\N	0	5
0	\N	0	5
0	\N	0	5
1	1	4	5
1	1	4	5
2	\N	5	0
2	\N	5	0
2	\N	5	0
2	\N	5	0
2	\N	5	0
2	\N	5	0
2	\N	5	0
3	3	4	4
{% if join_algorithm != 'grace_hash' -%}
t1 ALL FULL JOIN USING tn2 | bs = {{ block_size }}
1	4	5
1	4	5
2	5	0
2	5	0
2	5	0
2	5	0
2	5	0
2	5	0
2	5	0
3	4	4
\N	0	5
\N	0	5
\N	0	5
\N	0	5
\N	0	5
\N	0	5
\N	0	5
{% endif -%}
tn1 ALL INNER JOIN t2 | bs = {{ block_size }}
1	1	4	5
1	1	4	5
3	3	4	4
tn1 ALL LEFT JOIN t2 | bs = {{ block_size }}
1	1	val1	5
1	1	val1	5
3	3	val3	4
\N	0	val21	0
\N	0	val22	0
\N	0	val23	0
\N	0	val24	0
\N	0	val25	0
\N	0	val26	0
\N	0	val27	0
tn1 ALL RIGHT JOIN t2 | bs = {{ block_size }}
1	1	4	val11
1	1	4	val12
3	3	4	val3
\N	2	0	val22
\N	2	0	val23
\N	2	0	val24
\N	2	0	val25
\N	2	0	val26
\N	2	0	val27
\N	2	0	val28
tn1 ANY INNER JOIN t2 | bs = {{ block_size }}
1	1	4	5
3	3	4	4
tn1 ANY LEFT JOIN t2 | bs = {{ block_size }}
1	1	val1	5
3	3	val3	4
\N	0	val21	0
\N	0	val22	0
\N	0	val23	0
\N	0	val24	0
\N	0	val25	0
\N	0	val26	0
\N	0	val27	0
tn1 ANY RIGHT JOIN t2 | bs = {{ block_size }}
1	1	4	val11
1	1	4	val12
3	3	4	val3
\N	2	0	val22
\N	2	0	val23
\N	2	0	val24
\N	2	0	val25
\N	2	0	val26
\N	2	0	val27
\N	2	0	val28
tn1 ALL FULL JOIN t2 | bs = {{ block_size }}
1	1	4	5
1	1	4	5
3	3	4	4
\N	0	5	0
\N	0	5	0
\N	0	5	0
\N	0	5	0
\N	0	5	0
\N	0	5	0
\N	0	5	0
\N	2	0	5
\N	2	0	5
\N	2	0	5
\N	2	0	5
\N	2	0	5
\N	2	0	5
\N	2	0	5
tn1 ALL FULL JOIN USING t2 | bs = {{ block_size }}
1	4	5
1	4	5
2	0	5
2	0	5
2	0	5
2	0	5
2	0	5
2	0	5
2	0	5
3	4	4
\N	5	0
\N	5	0
\N	5	0
\N	5	0
\N	5	0
\N	5	0
\N	5	0
tn1 ALL INNER JOIN tn2 | bs = {{ block_size }}
1	1	4	5
1	1	4	5
3	3	4	4
tn1 ALL LEFT JOIN tn2 | bs = {{ block_size }}
1	1	val1	5
1	1	val1	5
3	3	val3	4
\N	\N	val21	0
\N	\N	val22	0
\N	\N	val23	0
\N	\N	val24	0
\N	\N	val25	0
\N	\N	val26	0
\N	\N	val27	0
tn1 ALL RIGHT JOIN tn2 | bs = {{ block_size }}
1	1	4	val11
1	1	4	val12
3	3	4	val3
\N	\N	0	val22
\N	\N	0	val23
\N	\N	0	val24
\N	\N	0	val25
\N	\N	0	val26
\N	\N	0	val27
\N	\N	0	val28
tn1 ANY INNER JOIN tn2 | bs = {{ block_size }}
1	1	4	5
3	3	4	4
tn1 ANY LEFT JOIN tn2 | bs = {{ block_size }}
1	1	val1	5
3	3	val3	4
\N	\N	val21	0
\N	\N	val22	0
\N	\N	val23	0
\N	\N	val24	0
\N	\N	val25	0
\N	\N	val26	0
\N	\N	val27	0
tn1 ANY RIGHT JOIN tn2 | bs = {{ block_size }}
1	1	4	val11
1	1	4	val12
3	3	4	val3
\N	\N	0	val22
\N	\N	0	val23
\N	\N	0	val24
\N	\N	0	val25
\N	\N	0	val26
\N	\N	0	val27
\N	\N	0	val28
tn1 ALL FULL JOIN tn2 | bs = {{ block_size }}
1	1	4	5
1	1	4	5
3	3	4	4
\N	\N	0	5
\N	\N	0	5
\N	\N	0	5
\N	\N	0	5
\N	\N	0	5
\N	\N	0	5
\N	\N	0	5
\N	\N	5	0
\N	\N	5	0
\N	\N	5	0
\N	\N	5	0
\N	\N	5	0
\N	\N	5	0
\N	\N	5	0
{% if join_algorithm != 'grace_hash' -%}
tn1 ALL FULL JOIN USING tn2 | bs = {{ block_size }}
1	4	5
1	4	5
3	4	4
\N	0	5
\N	0	5
\N	0	5
\N	0	5
\N	0	5
\N	0	5
\N	0	5
\N	5	0
\N	5	0
\N	5	0
\N	5	0
\N	5	0
\N	5	0
\N	5	0
{% endif -%}
{% endfor -%}
{% endfor -%}
